package com.xujianlong.gmallpublisher1.mapper;

import com.xujianlong.gmallpublisher1.bean.ProvinceStats;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

public interface ProvinceStatsMapper {
    @Select("select province_name,sum(order_amount) order_amount from province_stat_20210726" +
            "where toYYYYMMDD(stt)={date} group by province_id,province_name")
    List<ProvinceStats> selectProvinceStats(int date);
}
